Write Region

Command Prototype

Excel.WriteRange(objExcelWorkBook,sheet,strCell,data,bSave)

Command Description

Write data in the specified region of the sheet, data is an array. Performance will be compromised when the count of elements in a two-dimensional array is inconsistent

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)

strCell--The specified cell, supports two forms: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). When using cell names, it is case insensitive

data--Data to be written, two-dimensional array. If the array elements used are not aligned, they will be automatically aligned with null values before written. Please note the effect to avoid value overwriting

bSave--Save immediately after an operation